package com.lucher.mes.dao;

import java.util.List;

import com.lucher.mes.po.Productworkorder;
import com.lucher.mes.po.Worklinesectionmachine;
import org.apache.ibatis.annotations.Select;



public interface ProductworkorderMapper  {
    int deleteByPrimaryKey(Integer id);

    int insert(Productworkorder record);

    int insertSelective(Productworkorder record);

    Productworkorder selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Productworkorder record);

    int updateByPrimaryKey(Productworkorder record);
    
    //自定义接口
    List<Productworkorder> findByList(Productworkorder record);
    List<Productworkorder> findByListForPage(Productworkorder record);
    int findByCount(Productworkorder record);
    Productworkorder findByProductcodeAndOrdercode(Productworkorder record);
    int deleteByProductcode(Productworkorder record);
    Productworkorder findByProductcodeAndSerialnumber(Productworkorder record);
    //根据产品代码查询工序数量

    int findCountByProduct(String productCode);
}